FACTOR_DE_CONVERSION

"192.168.0.1:sipop"

Descriptions

FACTOR DE CONVERSION DE UN MATERIAL EN BODEGA

Fields

Name	Data type	Description
ID_FACTOR	CHAR (3)	ID factor de conversion
COD_PRODUCTO	VARCHAR (8)	Material que posee el factor de conversion
FACTOR_CONVERSION	FLOAT	Factor de conversion
PRESENTACION	CHAR (20)	Presentación de la conversion

Triggers

There are no triggers for table FACTOR_DE_CONVERSION

Indices

Index	Fields	Order
FK_FACTOR_DE_CONVERSION	COD_PRODUCTO	Ascending
IDX_FACTOR_DE_CONVERSION	COD_PRODUCTO	Ascending
PK_FACTOR_DE_CONVERSION	ID_FACTOR	Ascending

References

Table	Foreign Key	Fields	FK Fields	DEL Rule	UPD Rule
INVENTARIO	FK_FACTOR_DE_CONVERSION	COD_PRODUCTO	ID_ARTICULO	RESTRICT	RESTRICT

Referenced

There are no tables referenced by table FACTOR_DE_CONVERSION

Definition


CREATE TABLE FACTOR_DE_CONVERSION (
    ID_FACTOR CHAR (3) CHARACTER SET NONE NOT NULL COLLATE NONE,
    COD_PRODUCTO VARCHAR (8) CHARACTER SET NONE COLLATE NONE,
    FACTOR_CONVERSION FLOAT,
    PRESENTACION CHAR (20) CHARACTER SET NONE COLLATE NONE);

ALTER TABLE FACTOR_DE_CONVERSION ADD CONSTRAINT PK_FACTOR_DE_CONVERSION PRIMARY KEY (ID_FACTOR);
ALTER TABLE FACTOR_DE_CONVERSION ADD CONSTRAINT FK_FACTOR_DE_CONVERSION FOREIGN KEY (COD_PRODUCTO) REFERENCES INVENTARIO (ID_ARTICULO);
CREATE INDEX FK_FACTOR_DE_CONVERSION ON FACTOR_DE_CONVERSION (COD_PRODUCTO);
CREATE INDEX IDX_FACTOR_DE_CONVERSION ON FACTOR_DE_CONVERSION (COD_PRODUCTO);

This file was generated with EMS InterBase/FireBird Manager (www.ibmanager.com) at 09/06/2005 05:52 p.m.